package itman.elm.mapper;

import itman.elm.po.DeliveryAddress;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeliveryAddressMapper {
    /**
     * 1. 根据用户编号查询所属送货地址
     * @param userId
     * @return
     */
    @Select("select * from deliveryaddress where userId=#{userId}")
    public List<DeliveryAddress> listDeliveryAddressByUserId(String userId);

    /**
     *根据送货地址编号查询送货地址
     * @param daId
     * @return
     */

    @Select("select * from deliveryaddress where daId=#{daId}")
    public DeliveryAddress getDeliveryAddressById(Integer daId);

    /**
     *向送货地址表中添加一条记录
     * @param deliveryAddress
     * @return
     */
    @Insert("insert into deliveryaddress values(null,#{contactName},#{contactSex},#{contactTel},#{address},#{userId})")
    public int saveDeliveryAddress(DeliveryAddress deliveryAddress);

    /**
     * 根据送货地址编号删除一条记录
     * @param daId
     * @return
     */
    @Delete("delete from deliveryaddress where daId=#{daId}")
    public int removeDeliveryAddress(Integer daId);


    /**
     * 根据送货地址编号更新送货地址信息
     * @param deliveryAddress
     * @return
     */
    @Update("update deliveryaddress set contactName=#{contactName},contactSex=#{contactSex},contactTel=#{contactTel},address=#{address} where daId=#{daId}")
    public int updateDeliveryAddress(DeliveryAddress deliveryAddress);
}
